Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
ManufacturerID (FK)(PK) | A unique system assigned identifier for the Manufacturer. | ID_MF | Identity | integer | Manufacturer(PA_MF) |
ManufacturerFamilyCode (PK) | The UPC designated three digit coupon family code for the manufacturer item. | FC_FMY_MF | ProductCodeFamily | char(3) | |
CouponTypeCode (FK) | A code to denote the type of coupon, e.g. raincheck, manufacturer coupon, electronic coupon. | TY_CPN | Code2 | char(2) | CouponHandlingRule(RU_HN_CPN) |
Description | The description for a coupon family code for the manufacturer item. | DE_FMY_MF | DescriptionShort | varchar(255) | |
DispositionCode | A mnemonic code denoting what is to happen to the Coupons after they have been tendered. e.g. Remit to Issuer, Store, Discard. | DP_FMY_MF_CPN | Code4 | char(4) | |
ManufacturerCouponFamilyName | The name for a coupon family code for the manufacturer item. | NM_FMY_MF_CPN | Name | varchar(40) | |